﻿-- =============================================
-- Script Template
-- =============================================

if not exists (select * from TicketState where Name='New' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('New','#FFF53030',1)
if not exists (select * from TicketState where Name='Assigned' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Assigned','#FFA29DE1',1)
if not exists (select * from TicketState where Name='Accepted' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Accepted','#FF564AEB',1)
if not exists (select * from TicketState where Name='Started' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Started','#FF3526F9',1)
if not exists (select * from TicketState where Name='Reviewable' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Reviewable','#FF5AF167',1)
if not exists (select * from TicketState where Name='Resolved' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Resolved','#FF00F515',1)
if not exists (select * from TicketState where Name='Closed' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Closed','#FFCCF1D0',1)
if not exists (select * from TicketState where Name='Feedback' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Feedback','#FFB0B0B0',1)
if not exists (select * from TicketState where Name='Halted' and ProjectId is null) 
	insert into TicketState (Name, Color, IsActive) values ('Halted','#FFFF00A2',1)